<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>PrestaShop 的 CSV 导入</title>
<link rel="stylesheet" href="../css/reset.css" type="text/css" />
<link rel="stylesheet" href="../css/prettify.css" type="text/css" />
<script type="text/javascript" src="../js/prettify.js"></script>
</head>

<body onload="prettyPrint()">
<h1>PrestaShop 的 CSV 导入</h1>
<hr />
<ul>
  <li><a href="http://127.0.0.1/docs/csv_import/categories_import.csv">Sample Categories file</a> 【分类】</li>
  <li><a href="http://127.0.0.1/docs/csv_import/products_import.csv">Sample Products file</a> 【商品】</li>
  <li><a href="http://127.0.0.1/docs/csv_import/combinations_import.csv">Sample Combinations file</a> 【组合】</li>
  <li><a href="http://127.0.0.1/docs/csv_import/customers_import.csv">Sample Customers file</a> 【客户】</li>
  <li><a href="http://127.0.0.1/docs/csv_import/addresses_import.csv">Sample Addresses file</a> 【地址】</li>
  <li><a href="http://127.0.0.1/docs/csv_import/manufacturers_import.csv">Sample Manufacturers file</a> 【生产商】</li>
  <li><a href="http://127.0.0.1/docs/csv_import/suppliers_import.csv">Sample Suppliers file</a>【供应商】</li>
</ul>
<hr />
<h3>导入分类</h3>
<ol>
  <li>id; 【分类ID】</li>
  <li>Active (0/1); 【是否启用】</li>
  <li>Name*; 【风雷名称】</li>
  <li>Parent Category; 【父分类】</li>
  <li>Description; 【描述】</li>
  <li>Meta-title; 【Meta标题】</li>
  <li>Meta-keywords; 【Meta关键词】</li>
  <li>Meta-description; 【Meta描述】</li>
  <li>URL rewritten; 【URL重写】</li>
  <li>Image URL 【图片URL】</li>
</ol>
<pre class="prettyprint linenums">
id;Active (0/1);Name*;Parent Category;Description;Meta-title;Meta-keywords;Meta-description;URL rewritten;Image URL
2;1;iPods;Home;Now that you can buy movies from the iTunes Store and sync them to your iPod, the whole world is your theater.;;;;music-ipods;http://youlinktotheimage.com/img1000.jpg
3;1;Accessories;Home;Wonderful accessories for your iPod;;;;accessories-ipod;http://youlinktotheimage.com/img1001.jpg
4;1;Laptops;Home;The latest Intel processor, a bigger hard drive, plenty of memory, and even more new features all fit inside just one liberating inch. The new Mac laptops have the performance, power, and connectivity of a desktop computer. Without the desk part.;Apple laptops;Apple laptops MacBook Air;Powerful and chic Apple laptops;laptops;http://youlinktotheimage.com/img1002.jpg

</pre>
<hr />
<h3>导入商品</h3>
<ol>
  <li>id; 【商品ID】</li>
  <li>Active (0/1); 【】</li>
  <li>Name*; 【商品名称】</li>
  <li>Categories (x,y,z,...); 【所属分类】</li>
  <li>Price tax excl. Or Price tax excl; 【含税价】</li>
  <li>Tax rules id; 【计税规则ID】</li>
  <li>Wholesale price; 【批发价格】</li>
  <li>On sale (0/1); 【是否在售】</li>
  <li>Discount amount; 【折扣金额】</li>
  <li>Discount percent; 【折扣百分数】</li>
  <li>Discount from (yyy-mm-dd); 【折扣起始日】</li>
  <li>Discount to (yyy-mm-dd); 【折扣结束日】</li>
  <li>Reference #; 【参考】</li>
  <li>Supplier reference #; 【】</li>
  <li>Supplier; 【供应商】</li>
  <li>Manufacturer; 【生产商】</li>
  <li>EAN13; 【EAN条码】</li>
  <li>UPC; 【UPC条码】</li>
  <li>Ecotax; 【生态税】</li>
  <li>Weight; 【重量】</li>
  <li>Quantity; 【数量】</li>
  <li>Short description; 【简述】</li>
  <li>Description; 【介绍】</li>
  <li>Tags (x,y,z,...); 【标签】</li>
  <li>Meta-title; 【Meta标题】</li>
  <li>Meta-keywords; 【Meta关键词】</li>
  <li>Meta-description; 【Meta描述】</li>
  <li>URL rewritten; 【URL重写】</li>
  <li>Text when in-stock; 【】</li>
  <li>Text if back-order allowed; 【】</li>
  <li>Image URLs (x,y,z,...); 【图片URLs】</li>
  <li>Feature; 【】</li>
  <li>Only available online 【只在线销售】</li>
</ol>
<pre class="prettyprint linenums">
id;Active (0/1);Name*;Categories (x,y,z,...);Price tax excl. Or Price tax excl;Tax rules id;Wholesale price;On sale (0/1);Discount amount;Discount percent;Discount from (yyy-mm-dd);Discount to (yyy-mm-dd);Reference #;Supplier reference #;Supplier;Manufacturer;EAN13;UPC;Ecotax;Weight;Quantity;Short description;Description;Tags (x,y,z,...);Meta-title;Meta-keywords;Meta-description;URL rewritten;Text when in-stock;Text if back-order allowed;Image URLs (x,y,z,...);Feature;Only available online
1;1;iPod Nano;Home, iPods;49;1;;1;;;;;92458844;54778855;AppleStore;Apple Computer, Inc;;;;0.5;800;New design. New features. Now i….;Curved ahead of the curve. For those about to rock, we give you nine amazing colors. But that's only part of the story. Feel the curved, all-aluminum and glass de...;apple, ipod, nano;;;;ipod-nano;In stock;;http://youdomain.com/img.jpg, http://yourdomain.com/img1.jpg;;
2;1;iPod shuffle;Home, iPods;66.05;1;79;1;;;;;92458845;54778855;AppleStore;Apple Computer, Inc;;;;0;500;iPod shuffle, the world's most wearabl….;;ipod, shuffle;;;;ipod-shuffle;In stock;;http://youdomain.com/img25.jpg, http://yourdomain.com/img30.jpg;;

</pre>
<hr />
<h3>导入组合</h3>
<ol>
  <li>Product ID*;</li>
  <li>Options (Group:Value)*;</li>
  <li>Reference;</li>
  <li>Supplier reference;</li>
  <li>EAN13;</li>
  <li>UPC;</li>
  <li>Wholesale price;</li>
  <li>Price;</li>
  <li>Ecotax;</li>
  <li>Quantity;</li>
  <li>Weight;</li>
  <li>Default</li>
</ol>
<pre class="prettyprint linenums">
Product ID*;Options (Group:Value)*;Reference;Supplier reference;EAN13;UPC;Wholesale price;Price;Ecotax;Quantity;Weight;Default
1;"Color:Blue, Disk Space:16GO;";958456;254644;;;;41;;50;;
1;"Color:pINK, Disk Space:8GO;";958456;254644;;;;;;;;

</pre>
<hr />
<h3>导入客户</h3>
<ol>
  <li>id;</li>
  <li>Active (0/1);</li>
  <li>Gender ID (Mr=1, Ms=2, else 9);</li>
  <li>E-mail*;</li>
  <li>Password*;</li>
  <li>Birthday;</li>
  <li>Lastname*;</li>
  <li>Firstname*;</li>
  <li>Newletter (0/1);</li>
  <li>Opt-in (0/1)</li>
</ol>
<pre class="prettyprint linenums">
id;Active (0/1);Gender ID (Mr=1, Ms=2, else 9);E-mail*;Password*;Birthday;Lastname*;Firstname*;Newletter (0/1);Opt-in (0/1)
1;1;1;johndoe@prestashop.com;#res152EDRF;sous quelle forme ? ;Doe;John;1;1
2;1;2;mariedoe@prestashop.com;58@ret26#;sous quelle forme ? ;Doe;Marie;0;1

</pre>
<hr />
<h3>导入地址</h3>
<pre class="prettyprint linenums">


</pre>
<hr />
<h3>导入生产商</h3>
<pre class="prettyprint linenums">


</pre>
<hr />
<h3>导入供应商</h3>
<ol>
  <li>id;</li>
  <li>Active (0/1);</li>
  <li>Name*;</li>
  <li>Description;</li>
  <li>Short description;</li>
  <li>Meta-title;</li>
  <li>Meta-keywords;</li>
  <li>Meta-description</li>
</ol>
<pre class="prettyprint linenums">
id;Active (0/1);Name*;Description;Short description;Meta-title;Meta-keywords;Meta-description
1;1;Applestore;;;;;
2;1;Shure Online Store;;;;;

</pre>
</body>
</html>
